# 数据的修改
import pymysql
connect = pymysql.connect(
    host='127.0.0.1',
    db='study',
    user='root',
    password='mysql',
    port=3306,
    charset='utf8', )
# 创建游标
cur = connect.cursor()

sql = 'update Student set salary= salary+3000, name = "张三三" where name="张三" '
cur.execute(sql)
connect.commit()
